Overview

Dataset info

Number of variables180
Number of observations51739
Missing cells0 (0.0%)
Duplicate rows0 (0.0%)
Total size in memory71.1 MiB
Average record size in memory1.4 KiB

Variables types

Numeric41
Categorical57
Boolean71
Date0
URL0
Text (Unique)0
Rejected11
Unsupported0

Warnings

COMM_TKT_DT has a high cardinality: 449 distinct values Warning
COMM_VINTAGE_SCORE has 38587 (74.6%) zeros Zeros
DELIVERY_STATUS is highly skewed (γ1 = 102.1243294) Skewed
DELIVERY_STATUS has 39794 (76.9%) zeros Zeros
DUE_DATE_PAID has a high cardinality: 456 distinct values Warning
DUE_DATE_SYS has 40287 (77.9%) zeros Zeros
DUE_STS_SYS is highly correlated with DUE_DATE_SYS (ρ = 0.9585905194) Rejected
DUE_VINTAGE_SCORE has 40833 (78.9%) zeros Zeros
HELP_LINE_ACCOUNTVALUE/SURRENDERVALUE is highly skewed (γ1 = 26.97999883) Skewed
HELP_LINE_ACCOUNTVALUE/SURRENDERVALUE has 50853 (98.3%) zeros Zeros
HELP_LINE_BONUSINQUIRY has 51428 (99.4%) zeros Zeros
HELP_LINE_DUEDATE/AMOUNT has 49366 (95.4%) zeros Zeros
HELP_LINE_LOANENQUIRY is highly skewed (γ1 = 39.97374162) Skewed
HELP_LINE_LOANENQUIRY has 51597 (99.7%) zeros Zeros
HELP_LINE_OTHERS has 49496 (95.7%) zeros Zeros
HELP_LINE_POLICYPACKDISPATCHSTATUS/CLARIFICATION has 51388 (99.3%) zeros Zeros
HELP_LINE_POLICYSTATUS-ACTIVE/LAPSE has 50342 (97.3%) zeros Zeros
HELP_LINE_POSREQUESTSTATUSREQUIRED has 50977 (98.5%) zeros Zeros
HELP_LINE_PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY has 50568 (97.7%) zeros Zeros
HELP_LINE_PROBABLESURRENDER is highly skewed (γ1 = 22.69337676) Skewed
HELP_LINE_PROBABLESURRENDER has 51481 (99.5%) zeros Zeros
HELP_LINE_STATUSOFTHEPROPOSAL is highly skewed (γ1 = 31.94253099) Skewed
HELP_LINE_STATUSOFTHEPROPOSAL has 51457 (99.5%) zeros Zeros
IVR_ACCOUNT_VALUE/_SURRENDER_VALUE is highly skewed (γ1 = 62.98743417) Skewed
IVR_ACCOUNT_VALUE/_SURRENDER_VALUE has 51603 (99.7%) zeros Zeros
IVR_OTHERS has 51048 (98.7%) zeros Zeros
IVR_POLICY_STATUS_-_ACTIVE_/_LAPSE is highly skewed (γ1 = 23.17915677) Skewed
IVR_POLICY_STATUS_-_ACTIVE_/_LAPSE has 51082 (98.7%) zeros Zeros
IVR_PREMIUM_RECEIPT_REQUEST is highly skewed (γ1 = 22.87083409) Skewed
IVR_PREMIUM_RECEIPT_REQUEST has 51542 (99.6%) zeros Zeros
mapped_pol_id has a high cardinality: 48127 distinct values Warning
MEGA_MEGA_OTHERS is highly skewed (γ1 = 35.4290705) Skewed
MEGA_MEGA_OTHERS has 51167 (98.9%) zeros Zeros
MON_BNC_CHQ_VINTAGE_SCORE has 46838 (90.5%) zeros Zeros
MON_BOUNCE_COUNT has 46655 (90.2%) zeros Zeros
MON_CLEARANCE_COUNT is highly skewed (γ1 = 22.83197841) Skewed
MON_CLEARANCE_COUNT has 40667 (78.6%) zeros Zeros
MON_CLR_CHQ_VINTAGE_SCORE has 41055 (79.4%) zeros Zeros
MON_TKT_BOUNCE_DATE has a high cardinality: 324 distinct values Warning
MON_TKT_CLEARNACE_DATE has a high cardinality: 367 distinct values Warning
MY_MON_BNC_SYS is highly correlated with MON_BOUNCE_COUNT (ρ = 0.948047586) Rejected
PLAN_FAMILY_04 is highly correlated with PLAN_CAT_02 (ρ = 0.9697120372) Rejected
PLAN_TYPE_03 is highly correlated with PLAN_CAT_01 (ρ = 1) Rejected
PLAN_TYPE_05 is highly correlated with PLAN_FAMILY_07 (ρ = 0.9173916105) Rejected
PLAN_TYPE_07 is highly correlated with PLAN_FAMILY_14 (ρ = 1) Rejected
POL_COV_TERM has 15185 (29.3%) zeros Zeros
POL_PPT has 15184 (29.3%) zeros Zeros
POL_RIDER_COUNT has 32092 (62.0%) zeros Zeros
POLICY_CHNL_04 is highly correlated with PLAN_TYPE_03 (ρ = 0.9023277115) Rejected
POS_COUNT has 46128 (89.2%) zeros Zeros
POS_TKT_LOGGED_DATE1 has a high cardinality: 389 distinct values Warning
POS_VINTAGE_SCORE has 46302 (89.5%) zeros Zeros
REN_COUNT has 42428 (82.0%) zeros Zeros
REN_TKT_LOGGED_DATE1 has a high cardinality: 390 distinct values Warning
REN_VINTAGE_SCORE is highly correlated with REN_SYS_TOUCH_PT (ρ = 0.9115846582) Rejected
SCP_EML_SCP_EML_OTHERS has 45668 (88.3%) zeros Zeros
SCP_SMS_AGENT_-_OTHER is highly skewed (γ1 = 29.00202748) Skewed
SCP_SMS_AGENT_-_OTHER has 51665 (99.9%) zeros Zeros
SCP_SMS_LAPSATION_&_REVIVAL has 50680 (98.0%) zeros Zeros
SCP_SMS_PAYMENT_MODE has 45989 (88.9%) zeros Zeros
SCP_SMS_POS has constant value "0" Rejected
SCP_SMS_PREMIUM_PAYMENT has 44806 (86.6%) zeros Zeros
SCP_SMS_PROPOSAL has 48857 (94.4%) zeros Zeros
SCP_SMS_RENEWAL has 50360 (97.3%) zeros Zeros
TICKET_DATE has a high cardinality: 404 distinct values Warning
TICKET_DATE_15D has a high cardinality: 404 distinct values Warning
TKT_LOGGED_DATE has a high cardinality: 51631 distinct values Warning
TKT_LOGGED_DATE1 has a high cardinality: 45386 distinct values Warning
UNO_CS_COMM_COUNT is highly correlated with DELIVERY_STATUS (ρ = 0.9563908587) Rejected
UNO_CS_COMM_SYS is highly correlated with COMM_VINTAGE_SCORE (ρ = 0.9118394033) Rejected
UNO_EML_CAMPAIGN_RELATED_INFORMATION is highly skewed (γ1 = 29.60723533) Skewed
UNO_EML_CAMPAIGN_RELATED_INFORMATION has 51588 (99.7%) zeros Zeros
UNO_EML_OTHERS has 50185 (97.0%) zeros Zeros
UNO_EML_POLICY_SERVICING_-_CLARIFICATION/_FOLLOW_UP has 51406 (99.4%) zeros Zeros
UNO_EML_POLICY_STATUS_-_ACTIVE_/_LAPSE has 51255 (99.1%) zeros Zeros

Variables

CLEAN_INTENT
Categorical

Distinct count13
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
DUEDATE/AMOUNT
13055
ACCOUNTVALUE/SURRENDERVALUE
7574
POLICYSTATUS-ACTIVE/LAPSE
7338
Other values (10)
23772
ValueCountFrequency (%) 
DUEDATE/AMOUNT 13055 25.2%
 
ACCOUNTVALUE/SURRENDERVALUE 7574 14.6%
 
POLICYSTATUS-ACTIVE/LAPSE 7338 14.2%
 
PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY 5434 10.5%
 
ECS/CREDITCARDINQUIRY 3486 6.7%
 
PREMIUMRECEIPTREQUEST 3437 6.6%
 
PROBABLESURRENDER 2643 5.1%
 
POSREQUESTSTATUSREQUIRED 2447 4.7%
 
BONUSINQUIRY 2019 3.9%
 
POLICYPACKDISPATCHSTATUS/CLARIFICATION 1503 2.9%
 
Other values (3) 2803 5.4%
 
Max length39
Mean length22.52210132
Min length11
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

CLI_EDUCATION_CAT_01
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51707
1
 
32
ValueCountFrequency (%) 
0 51707 99.9%
 
1 32 0.1%
 

CLI_EDUCATION_CAT_02
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
43627
1
 
8112
ValueCountFrequency (%) 
0 43627 84.3%
 
1 8112 15.7%
 

CLI_EDUCATION_CAT_03
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
33734
1
18005
ValueCountFrequency (%) 
0 33734 65.2%
 
1 18005 34.8%
 

CLI_EDUCATION_CAT_04
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
41333
1
10406
ValueCountFrequency (%) 
0 41333 79.9%
 
1 10406 20.1%
 

CLI_HNI_IND_L
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
46503
1
 
5236
ValueCountFrequency (%) 
0 46503 89.9%
 
1 5236 10.1%
 

CLI_HNI_IND_N
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
27178
0
24561
ValueCountFrequency (%) 
1 27178 52.5%
 
0 24561 47.5%
 

CLI_HNI_IND_Y
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
47598
1
 
4141
ValueCountFrequency (%) 
0 47598 92.0%
 
1 4141 8.0%
 

CLI_OCCUPATION_CAT_01
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50119
1
 
1620
ValueCountFrequency (%) 
0 50119 96.9%
 
1 1620 3.1%
 

CLI_OCCUPATION_CAT_02
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
32353
1
19386
ValueCountFrequency (%) 
0 32353 62.5%
 
1 19386 37.5%
 

CLI_OCCUPATION_CAT_03
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51114
1
 
625
ValueCountFrequency (%) 
0 51114 98.8%
 
1 625 1.2%
 

CLI_OCCUPATION_CAT_04
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
40249
1
11490
ValueCountFrequency (%) 
0 40249 77.8%
 
1 11490 22.2%
 

CLI_OCCUPATION_CAT_05
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51422
1
 
317
ValueCountFrequency (%) 
0 51422 99.4%
 
1 317 0.6%
 

CLI_OCCUPATION_CAT_06
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51291
1
 
448
ValueCountFrequency (%) 
0 51291 99.1%
 
1 448 0.9%
 

CLI_OCCUPATION_CAT_07
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51618
1
 
121
ValueCountFrequency (%) 
0 51618 99.8%
 
1 121 0.2%
 

CLI_OCCUPATION_CAT_08
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
49191
1
 
2548
ValueCountFrequency (%) 
0 49191 95.1%
 
1 2548 4.9%
 

CLI_SNGL_MLTPL_PLCYHLDR_FLG_MULTIPLE
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
40560
1
11179
ValueCountFrequency (%) 
0 40560 78.4%
 
1 11179 21.6%
 

CLI_SNGL_MLTPL_PLCYHLDR_FLG_SINGLE
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
26363
1
25376
ValueCountFrequency (%) 
0 26363 51.0%
 
1 25376 49.0%
 

COMM_TKT_DT
Categorical

Distinct count449
Unique (%)0.9%
Missing (%)0.0%
Missing (n)0
0
38343
3/12/2018 00:00
 
92
3/13/2018 0:00
 
77
Other values (446)
13227
ValueCountFrequency (%) 
0 38343 74.1%
 
3/12/2018 00:00 92 0.2%
 
3/13/2018 0:00 77 0.1%
 
3/20/2018 0:00 74 0.1%
 
3/7/2018 00:00 73 0.1%
 
3/19/2019 0:00 70 0.1%
 
4/10/2018 00:00 65 0.1%
 
3/10/2018 00:00 65 0.1%
 
4/6/2018 00:00 62 0.1%
 
2/26/2018 0:00 61 0.1%
 
Other values (439) 12757 24.7%
 
Max length16
Mean length4.441156574
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

COMM_VINTAGE_SCORE
Numeric

Distinct count15
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.649645335
Minimum0
Maximum14
Zeros (%)74.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile14
Maximum14
Range14
Interquartile range1

Descriptive statistics

Standard deviation4.916194571
Coef of variation1.855416083
Kurtosis0.4149175488
Mean2.649645335
MAD3.98343494
Skewness1.478102715
Sum137090
Variance24.16896906
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=15)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 4.5 6.5 7.5 ... 10.5 11.5 12.5 13.5 14. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 38587 74.6%
 
14 3462 6.7%
 
13 2013 3.9%
 
12 1389 2.7%
 
11 1111 2.1%
 
10 912 1.8%
 
8 752 1.5%
 
9 722 1.4%
 
7 539 1.0%
 
6 429 0.8%
 
Other values (5) 1823 3.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 38587 74.6%
 
1 360 0.7%
 
2 329 0.6%
 
3 376 0.7%
 
4 353 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
14 3462 6.7%
 
13 2013 3.9%
 
12 1389 2.7%
 
11 1111 2.1%
 
10 912 1.8%
 

DELIVERY_STATUS
Numeric

Distinct count46
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.781692727
Minimum0
Maximum655
Zeros (%)76.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile4
Maximum655
Range655
Interquartile range0

Descriptive statistics

Standard deviation3.79676497
Coef of variation4.857106686
Kurtosis17115.31074
Mean0.781692727
MAD1.202446138
Skewness102.1243294
Sum40444
Variance14.41542424
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=46)
Histogram
Histogram with variable size bins (bins=[0.00e+00 5.00e-01 1.50e+00 2.50e+00 3.50e+00 ... 2.05e+01 2.85e+01 4.40e+01 6.35e+01 6.55e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 39794 76.9%
 
1 4518 8.7%
 
2 2813 5.4%
 
3 1243 2.4%
 
4 1043 2.0%
 
6 473 0.9%
 
5 463 0.9%
 
8 267 0.5%
 
7 242 0.5%
 
9 162 0.3%
 
Other values (36) 721 1.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 39794 76.9%
 
1 4518 8.7%
 
2 2813 5.4%
 
3 1243 2.4%
 
4 1043 2.0%
 

Maximum 5 values

ValueCountFrequency (%) 
655 1 < 0.1%
 
163 1 < 0.1%
 
64 1 < 0.1%
 
63 1 < 0.1%
 
60 1 < 0.1%
 

DUE_DATE_PAID
Categorical

Distinct count456
Unique (%)0.9%
Missing (%)0.0%
Missing (n)0
0
40287
2/28/2019 0:00
 
113
3/31/2018 0:00
 
96
Other values (453)
11243
ValueCountFrequency (%) 
0 40287 77.9%
 
2/28/2019 0:00 113 0.2%
 
3/31/2018 0:00 96 0.2%
 
2/28/2018 0:00 88 0.2%
 
6/30/2018 0:00 76 0.1%
 
9/30/2018 0:00 74 0.1%
 
3/30/2018 0:00 67 0.1%
 
3/28/2018 0:00 67 0.1%
 
12/31/2018 0:00 65 0.1%
 
12/30/2018 0:00 62 0.1%
 
Other values (446) 10744 20.8%
 
Max length16
Mean length3.939832621
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

DUE_DATE_SYS
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.2345812637
Minimum0
Maximum8
Zeros (%)77.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.4589931282
Coef of variation1.956648716
Kurtosis5.808244109
Mean0.2345812637
MAD0.3653172798
Skewness1.956190933
Sum12137
Variance0.2106746918
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=8)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4.5 8. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 40287 77.9%
 
1 10842 21.0%
 
2 563 1.1%
 
3 29 0.1%
 
4 12 < 0.1%
 
5 4 < 0.1%
 
8 1 < 0.1%
 
6 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 40287 77.9%
 
1 10842 21.0%
 
2 563 1.1%
 
3 29 0.1%
 
4 12 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 < 0.1%
 
6 1 < 0.1%
 
5 4 < 0.1%
 
4 12 < 0.1%
 
3 29 0.1%
 

DUE_STS_SYS
Highly correlated

This variable is highly correlated with DUE_DATE_SYS and should be ignored for analysis

Correlation0.9585905194

DUE_VINTAGE_SCORE
Numeric

Distinct count15
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.847658439
Minimum0
Maximum14
Zeros (%)78.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile13
Maximum14
Range14
Interquartile range0

Descriptive statistics

Standard deviation4.055571979
Coef of variation2.194979273
Kurtosis2.544727691
Mean1.847658439
MAD2.936406052
Skewness2.023690771
Sum95596
Variance16.44766407
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=15)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 5.5 9.5 11.5 12.5 13.5 14. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 40833 78.9%
 
14 1574 3.0%
 
13 1224 2.4%
 
12 1023 2.0%
 
11 872 1.7%
 
10 786 1.5%
 
9 683 1.3%
 
7 653 1.3%
 
8 632 1.2%
 
6 618 1.2%
 
Other values (5) 2841 5.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 40833 78.9%
 
1 611 1.2%
 
2 538 1.0%
 
3 558 1.1%
 
4 593 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
14 1574 3.0%
 
13 1224 2.4%
 
12 1023 2.0%
 
11 872 1.7%
 
10 786 1.5%
 

ECS_FLAG_No
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
32535
1
19204
ValueCountFrequency (%) 
0 32535 62.9%
 
1 19204 37.1%
 

ECS_FLAG_Yes
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
34388
1
17351
ValueCountFrequency (%) 
0 34388 66.5%
 
1 17351 33.5%
 

HELP_LINE_ACCOUNTVALUE/SURRENDERVALUE
Numeric

Distinct count15
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.02524208044
Minimum0
Maximum14
Zeros (%)98.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum14
Range14
Interquartile range0

Descriptive statistics

Standard deviation0.2881904392
Coef of variation11.41706365
Kurtosis998.7622888
Mean0.02524208044
MAD0.04961964927
Skewness26.97999883
Sum1306
Variance0.08305372923
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=15)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 5.5 14. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50853 98.3%
 
1 732 1.4%
 
2 93 0.2%
 
3 18 < 0.1%
 
4 9 < 0.1%
 
5 8 < 0.1%
 
10 6 < 0.1%
 
14 3 < 0.1%
 
12 3 < 0.1%
 
9 3 < 0.1%
 
Other values (5) 11 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50853 98.3%
 
1 732 1.4%
 
2 93 0.2%
 
3 18 < 0.1%
 
4 9 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
14 3 < 0.1%
 
13 2 < 0.1%
 
12 3 < 0.1%
 
11 1 < 0.1%
 
10 6 < 0.1%
 

HELP_LINE_BONUSINQUIRY
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.006938672955
Minimum0
Maximum4
Zeros (%)99.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum4
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.09576733813
Coef of variation13.80196743
Kurtosis369.1444831
Mean0.006938672955
MAD0.01379393002
Skewness17.05750961
Sum359
Variance0.009171383053
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=5)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51428 99.4%
 
1 273 0.5%
 
2 29 0.1%
 
3 8 < 0.1%
 
4 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51428 99.4%
 
1 273 0.5%
 
2 29 0.1%
 
3 8 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4 1 < 0.1%
 
3 8 < 0.1%
 
2 29 0.1%
 
1 273 0.5%
 
0 51428 99.4%
 

HELP_LINE_DUEDATE/AMOUNT
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.05523879472
Minimum0
Maximum7
Zeros (%)95.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum7
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.2821272771
Coef of variation5.107411892
Kurtosis86.59379255
Mean0.05523879472
MAD0.1054105545
Skewness7.432349426
Sum2858
Variance0.07959580047
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=8)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 5.5 7. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 49366 95.4%
 
1 2021 3.9%
 
2 273 0.5%
 
3 49 0.1%
 
4 15 < 0.1%
 
5 10 < 0.1%
 
7 4 < 0.1%
 
6 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 49366 95.4%
 
1 2021 3.9%
 
2 273 0.5%
 
3 49 0.1%
 
4 15 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7 4 < 0.1%
 
6 1 < 0.1%
 
5 10 < 0.1%
 
4 15 < 0.1%
 
3 49 0.1%
 

HELP_LINE_ECS/CREDITCARDINQUIRY
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51040
1
 
621
2
 
67
ValueCountFrequency (%) 
0 51040 98.6%
 
1 621 1.2%
 
2 67 0.1%
 
3 11 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

HELP_LINE_LOANENQUIRY
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.00423278378
Minimum0
Maximum9
Zeros (%)99.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum9
Range9
Interquartile range0

Descriptive statistics

Standard deviation0.1006447402
Coef of variation23.77743476
Kurtosis2322.820256
Mean0.00423278378
MAD0.008442333431
Skewness39.97374162
Sum219
Variance0.01012936372
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=8)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4.5 9. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51597 99.7%
 
1 100 0.2%
 
2 26 0.1%
 
4 7 < 0.1%
 
3 6 < 0.1%
 
9 1 < 0.1%
 
7 1 < 0.1%
 
5 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51597 99.7%
 
1 100 0.2%
 
2 26 0.1%
 
3 6 < 0.1%
 
4 7 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9 1 < 0.1%
 
7 1 < 0.1%
 
5 1 < 0.1%
 
4 7 < 0.1%
 
3 6 < 0.1%
 

HELP_LINE_OTHERS
Numeric

Distinct count9
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.05320937784
Minimum0
Maximum8
Zeros (%)95.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.2802847861
Coef of variation5.267582472
Kurtosis93.75495863
Mean0.05320937784
MAD0.1018052674
Skewness7.665525559
Sum2753
Variance0.07855956131
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=9)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 8. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 49496 95.7%
 
1 1862 3.6%
 
2 301 0.6%
 
3 53 0.1%
 
4 17 < 0.1%
 
7 4 < 0.1%
 
5 4 < 0.1%
 
8 1 < 0.1%
 
6 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 49496 95.7%
 
1 1862 3.6%
 
2 301 0.6%
 
3 53 0.1%
 
4 17 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 < 0.1%
 
7 4 < 0.1%
 
6 1 < 0.1%
 
5 4 < 0.1%
 
4 17 < 0.1%
 

HELP_LINE_PAYMENTPROCEDURE/ONLINEPAYMENTPROCEDURE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51528
1
 
203
2
 
8
ValueCountFrequency (%) 
0 51528 99.6%
 
1 203 0.4%
 
2 8 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

HELP_LINE_POLICYPACKDISPATCHSTATUS/CLARIFICATION
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.008272289762
Minimum0
Maximum4
Zeros (%)99.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum4
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.1086234509
Coef of variation13.13100169
Kurtosis328.858875
Mean0.008272289762
MAD0.01643234026
Skewness16.26993297
Sum428
Variance0.01179905408
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=5)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51388 99.3%
 
1 288 0.6%
 
2 51 0.1%
 
3 10 < 0.1%
 
4 2 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51388 99.3%
 
1 288 0.6%
 
2 51 0.1%
 
3 10 < 0.1%
 
4 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4 2 < 0.1%
 
3 10 < 0.1%
 
2 51 0.1%
 
1 288 0.6%
 
0 51388 99.3%
 

HELP_LINE_POLICYSTATUS-ACTIVE/LAPSE
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.03523454261
Minimum0
Maximum16
Zeros (%)97.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum16
Range16
Interquartile range0

Descriptive statistics

Standard deviation0.254943297
Coef of variation7.235606825
Kurtosis686.5694774
Mean0.03523454261
MAD0.0685663559
Skewness16.90375184
Sum1823
Variance0.06499608467
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=8)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 6.5 16. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50342 97.3%
 
1 1112 2.1%
 
2 203 0.4%
 
3 61 0.1%
 
5 10 < 0.1%
 
4 8 < 0.1%
 
16 2 < 0.1%
 
8 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50342 97.3%
 
1 1112 2.1%
 
2 203 0.4%
 
3 61 0.1%
 
4 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
16 2 < 0.1%
 
8 1 < 0.1%
 
5 10 < 0.1%
 
4 8 < 0.1%
 
3 61 0.1%
 

HELP_LINE_POSREQUESTSTATUSREQUIRED
Numeric

Distinct count9
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.02021685769
Minimum0
Maximum9
Zeros (%)98.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum9
Range9
Interquartile range0

Descriptive statistics

Standard deviation0.1973407993
Coef of variation9.761200396
Kurtosis364.2934262
Mean0.02021685769
MAD0.03983821699
Skewness15.63232313
Sum1046
Variance0.03894339106
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=9)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 5.5 9. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50977 98.5%
 
1 594 1.1%
 
2 100 0.2%
 
3 46 0.1%
 
5 8 < 0.1%
 
4 8 < 0.1%
 
7 3 < 0.1%
 
6 2 < 0.1%
 
9 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50977 98.5%
 
1 594 1.1%
 
2 100 0.2%
 
3 46 0.1%
 
4 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9 1 < 0.1%
 
7 3 < 0.1%
 
6 2 < 0.1%
 
5 8 < 0.1%
 
4 8 < 0.1%
 

HELP_LINE_PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY
Numeric

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.02620846943
Minimum0
Maximum6
Zeros (%)97.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum6
Range6
Interquartile range0

Descriptive statistics

Standard deviation0.1865464888
Coef of variation7.117794088
Kurtosis117.7451675
Mean0.02620846943
MAD0.05123059519
Skewness9.204836731
Sum1356
Variance0.03479959247
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=6)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 6. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50568 97.7%
 
1 1027 2.0%
 
2 114 0.2%
 
3 21 < 0.1%
 
4 8 < 0.1%
 
6 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50568 97.7%
 
1 1027 2.0%
 
2 114 0.2%
 
3 21 < 0.1%
 
4 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6 1 < 0.1%
 
4 8 < 0.1%
 
3 21 < 0.1%
 
2 114 0.2%
 
1 1027 2.0%
 

HELP_LINE_PREMIUMRECEIPTREQUEST
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51442
1
 
274
2
 
21
ValueCountFrequency (%) 
0 51442 99.4%
 
1 274 0.5%
 
2 21 < 0.1%
 
3 2 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

HELP_LINE_PROBABLESURRENDER
Numeric

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.005663039487
Minimum0
Maximum5
Zeros (%)99.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.08829400595
Coef of variation15.591275
Kurtosis780.2717963
Mean0.005663039487
MAD0.01126960072
Skewness22.69337676
Sum293
Variance0.007795831486
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=6)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 5. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51481 99.5%
 
1 236 0.5%
 
2 15 < 0.1%
 
3 3 < 0.1%
 
5 2 < 0.1%
 
4 2 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51481 99.5%
 
1 236 0.5%
 
2 15 < 0.1%
 
3 3 < 0.1%
 
4 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5 2 < 0.1%
 
4 2 < 0.1%
 
3 3 < 0.1%
 
2 15 < 0.1%
 
1 236 0.5%
 

HELP_LINE_STATUSOFTHEPROPOSAL
Numeric

Distinct count9
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.007789095267
Minimum0
Maximum10
Zeros (%)99.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum10
Range10
Interquartile range0

Descriptive statistics

Standard deviation0.1317345628
Coef of variation16.91269117
Kurtosis1621.614915
Mean0.007789095267
MAD0.01549328264
Skewness31.94253099
Sum403
Variance0.01735399503
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=9)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 4.5 10. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51457 99.5%
 
1 213 0.4%
 
2 45 0.1%
 
3 13 < 0.1%
 
4 6 < 0.1%
 
5 2 < 0.1%
 
10 1 < 0.1%
 
9 1 < 0.1%
 
8 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51457 99.5%
 
1 213 0.4%
 
2 45 0.1%
 
3 13 < 0.1%
 
4 6 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
10 1 < 0.1%
 
9 1 < 0.1%
 
8 1 < 0.1%
 
5 2 < 0.1%
 
4 6 < 0.1%
 

HELP_LINE_SYS
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
43429
1
 
8310
ValueCountFrequency (%) 
0 43429 83.9%
 
1 8310 16.1%
 

INCOME_BUK_01
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
38461
1
13278
ValueCountFrequency (%) 
0 38461 74.3%
 
1 13278 25.7%
 

INCOME_BUK_02
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
38777
1
12962
ValueCountFrequency (%) 
0 38777 74.9%
 
1 12962 25.1%
 

INCOME_BUK_03
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
44914
1
 
6825
ValueCountFrequency (%) 
0 44914 86.8%
 
1 6825 13.2%
 

INCOME_BUK_04
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
49211
1
 
2528
ValueCountFrequency (%) 
0 49211 95.1%
 
1 2528 4.9%
 

INCOME_BUK_05
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50777
1
 
962
ValueCountFrequency (%) 
0 50777 98.1%
 
1 962 1.9%
 

ind_surr
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50378
1
 
1361
ValueCountFrequency (%) 
0 50378 97.4%
 
1 1361 2.6%
 

IVR_ACCOUNT_VALUE/_SURRENDER_VALUE
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.004735306055
Minimum0
Maximum16
Zeros (%)99.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum16
Range16
Interquartile range0

Descriptive statistics

Standard deviation0.1376172043
Coef of variation29.06194503
Kurtosis5664.615304
Mean0.004735306055
MAD0.009445717868
Skewness62.98743417
Sum245
Variance0.01893849492
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 5.5 16. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51603 99.7%
 
1 94 0.2%
 
2 24 < 0.1%
 
5 5 < 0.1%
 
4 5 < 0.1%
 
3 3 < 0.1%
 
7 2 < 0.1%
 
16 1 < 0.1%
 
13 1 < 0.1%
 
6 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51603 99.7%
 
1 94 0.2%
 
2 24 < 0.1%
 
3 3 < 0.1%
 
4 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
16 1 < 0.1%
 
13 1 < 0.1%
 
7 2 < 0.1%
 
6 1 < 0.1%
 
5 5 < 0.1%
 

IVR_OTHERS
Numeric

Distinct count9
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.01812945747
Minimum0
Maximum11
Zeros (%)98.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum11
Range11
Interquartile range0

Descriptive statistics

Standard deviation0.1848046051
Coef of variation10.19360924
Kurtosis499.4467459
Mean0.01812945747
MAD0.03577465915
Skewness17.16682339
Sum938
Variance0.03415274206
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=9)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 4.5 11. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51048 98.7%
 
1 534 1.0%
 
2 107 0.2%
 
3 29 0.1%
 
4 13 < 0.1%
 
6 3 < 0.1%
 
5 3 < 0.1%
 
11 1 < 0.1%
 
7 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51048 98.7%
 
1 534 1.0%
 
2 107 0.2%
 
3 29 0.1%
 
4 13 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 < 0.1%
 
7 1 < 0.1%
 
6 3 < 0.1%
 
5 3 < 0.1%
 
4 13 < 0.1%
 

IVR_POLICY_STATUS_-_ACTIVE_/_LAPSE
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.01874794642
Minimum0
Maximum13
Zeros (%)98.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum13
Range13
Interquartile range0

Descriptive statistics

Standard deviation0.21275091
Coef of variation11.34795807
Kurtosis889.0970947
Mean0.01874794642
MAD0.03701975683
Skewness23.17915677
Sum970
Variance0.04526294971
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 6.5 13. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51082 98.7%
 
1 482 0.9%
 
2 118 0.2%
 
3 29 0.1%
 
4 10 < 0.1%
 
5 7 < 0.1%
 
6 5 < 0.1%
 
11 3 < 0.1%
 
7 2 < 0.1%
 
13 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51082 98.7%
 
1 482 0.9%
 
2 118 0.2%
 
3 29 0.1%
 
4 10 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
13 1 < 0.1%
 
11 3 < 0.1%
 
7 2 < 0.1%
 
6 5 < 0.1%
 
5 7 < 0.1%
 

IVR_PREMIUM_RECEIPT_REQUEST
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.00427143934
Minimum0
Maximum5
Zeros (%)99.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.07409641131
Coef of variation17.34694219
Kurtosis774.7164173
Mean0.00427143934
MAD0.008510351049
Skewness22.87083409
Sum221
Variance0.005490278169
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=5)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 5. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51542 99.6%
 
1 178 0.3%
 
2 16 < 0.1%
 
3 2 < 0.1%
 
5 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51542 99.6%
 
1 178 0.3%
 
2 16 < 0.1%
 
3 2 < 0.1%
 
5 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 < 0.1%
 
3 2 < 0.1%
 
2 16 < 0.1%
 
1 178 0.3%
 
0 51542 99.6%
 

IVR_SYS
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50172
1
 
1567
ValueCountFrequency (%) 
0 50172 97.0%
 
1 1567 3.0%
 

Lock_in_ind
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
48373
1
 
3366
ValueCountFrequency (%) 
0 48373 93.5%
 
1 3366 6.5%
 

mapped_pol_id
Categorical

Distinct count48127
Unique (%)93.0%
Missing (%)0.0%
Missing (n)0
DKVMAEVMYSAEAEVMWL
 
18
ZTOOCGVMWLOOWLZTOO
 
14
WLOOWLDKZTVMOOBFZT
 
10
Other values (48124)
51697
ValueCountFrequency (%) 
DKVMAEVMYSAEAEVMWL 18 < 0.1%
 
ZTOOCGVMWLOOWLZTOO 14 < 0.1%
 
WLOOWLDKZTVMOOBFZT 10 < 0.1%
 
WLOOZTDKOOAEDKWLWL 9 < 0.1%
 
XRAEOOAECGXRAEOOZT 8 < 0.1%
 
ZTAEZTZTCGOOOOYSBF 7 < 0.1%
 
BFCGXRWLOOBFWLBFDK 7 < 0.1%
 
DKOOVMOOZTWLXRYSAE 6 < 0.1%
 
DKAEDKOOOOVMBFBFVM 6 < 0.1%
 
DKWLWLZTAEOODKBFOO 6 < 0.1%
 
Other values (48117) 51648 99.8%
 
Max length18
Mean length18
Min length18
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

MEGA_MEGA_OTHERS
Numeric

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.01206053461
Minimum0
Maximum13
Zeros (%)98.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum13
Range13
Interquartile range0

Descriptive statistics

Standard deviation0.1373806523
Coef of variation11.39092559
Kurtosis2736.516096
Mean0.01206053461
MAD0.02385439897
Skewness35.4290705
Sum624
Variance0.01887344363
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=7)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 13. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51167 98.9%
 
1 547 1.1%
 
2 18 < 0.1%
 
3 4 < 0.1%
 
13 1 < 0.1%
 
12 1 < 0.1%
 
4 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51167 98.9%
 
1 547 1.1%
 
2 18 < 0.1%
 
3 4 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
13 1 < 0.1%
 
12 1 < 0.1%
 
4 1 < 0.1%
 
3 4 < 0.1%
 
2 18 < 0.1%
 

MEGA_SCP_MG_1
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51106
1
 
607
2
 
25
ValueCountFrequency (%) 
0 51106 98.8%
 
1 607 1.2%
 
2 25 < 0.1%
 
3 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_10
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51692
1
 
47
ValueCountFrequency (%) 
0 51692 99.9%
 
1 47 0.1%
 

MEGA_SCP_MG_11
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51727
1
 
7
2
 
5
ValueCountFrequency (%) 
0 51727 > 99.9%
 
1 7 < 0.1%
 
2 5 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_12
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51698
1
 
41
ValueCountFrequency (%) 
0 51698 99.9%
 
1 41 0.1%
 

MEGA_SCP_MG_13
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51719
1
 
16
2
 
4
ValueCountFrequency (%) 
0 51719 > 99.9%
 
1 16 < 0.1%
 
2 4 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_14
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51684
1
 
50
2
 
5
ValueCountFrequency (%) 
0 51684 99.9%
 
1 50 0.1%
 
2 5 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_2
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51229
1
 
464
2
 
45
ValueCountFrequency (%) 
0 51229 99.0%
 
1 464 0.9%
 
2 45 0.1%
 
3 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_3
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51557
1
 
168
2
 
13
ValueCountFrequency (%) 
0 51557 99.6%
 
1 168 0.3%
 
2 13 < 0.1%
 
3 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_4
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51646
1
 
93
ValueCountFrequency (%) 
0 51646 99.8%
 
1 93 0.2%
 

MEGA_SCP_MG_5
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51552
1
 
174
2
 
13
ValueCountFrequency (%) 
0 51552 99.6%
 
1 174 0.3%
 
2 13 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_6
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51579
1
 
157
2
 
3
ValueCountFrequency (%) 
0 51579 99.7%
 
1 157 0.3%
 
2 3 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_7
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51640
1
 
79
2
 
19
ValueCountFrequency (%) 
0 51640 99.8%
 
1 79 0.2%
 
2 19 < 0.1%
 
3 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SCP_MG_9
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51694
1
 
44
2
 
1
ValueCountFrequency (%) 
0 51694 99.9%
 
1 44 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MEGA_SYS
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
49400
1
 
2339
ValueCountFrequency (%) 
0 49400 95.5%
 
1 2339 4.5%
 

MON_BNC_CHQ_VINTAGE_SCORE
Numeric

Distinct count16
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.8861787047
Minimum0
Maximum15
Zeros (%)90.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile10
Maximum15
Range15
Interquartile range0

Descriptive statistics

Standard deviation3.031751473
Coef of variation3.421151352
Kurtosis10.77210086
Mean0.8861787047
MAD1.604470058
Skewness3.461894393
Sum45850
Variance9.191516997
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=16)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 7.5 10.5 12.5 13.5 14.5 15. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 46838 90.5%
 
13 617 1.2%
 
15 479 0.9%
 
12 477 0.9%
 
11 402 0.8%
 
14 384 0.7%
 
8 350 0.7%
 
10 336 0.6%
 
9 279 0.5%
 
7 257 0.5%
 
Other values (6) 1320 2.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 46838 90.5%
 
1 232 0.4%
 
2 200 0.4%
 
3 218 0.4%
 
4 214 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
15 479 0.9%
 
14 384 0.7%
 
13 617 1.2%
 
12 477 0.9%
 
11 402 0.8%
 

MON_BOUNCE_COUNT
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.111656584
Minimum0
Maximum4
Zeros (%)90.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum4
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.3567834685
Coef of variation3.195364355
Kurtosis12.6675874
Mean0.111656584
MAD0.2013698729
Skewness3.434898072
Sum5777
Variance0.1272944434
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=5)
ValueCountFrequency (%) 
0 46655 90.2%
 
1 4424 8.6%
 
2 628 1.2%
 
3 31 0.1%
 
4 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 46655 90.2%
 
1 4424 8.6%
 
2 628 1.2%
 
3 31 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4 1 < 0.1%
 
3 31 0.1%
 
2 628 1.2%
 
1 4424 8.6%
 
0 46655 90.2%
 

MON_CLEARANCE_COUNT
Numeric

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.2260577128
Minimum0
Maximum52
Zeros (%)78.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum52
Range52
Interquartile range0

Descriptive statistics

Standard deviation0.5031123703
Coef of variation2.225592589
Kurtosis2186.596575
Mean0.2260577128
MAD0.3553640002
Skewness22.83197841
Sum11696
Variance0.2531220571
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=7)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 52. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 40667 78.6%
 
1 10528 20.3%
 
2 528 1.0%
 
3 12 < 0.1%
 
4 2 < 0.1%
 
52 1 < 0.1%
 
16 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 40667 78.6%
 
1 10528 20.3%
 
2 528 1.0%
 
3 12 < 0.1%
 
4 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
52 1 < 0.1%
 
16 1 < 0.1%
 
4 2 < 0.1%
 
3 12 < 0.1%
 
2 528 1.0%
 

MON_CLR_CHQ_VINTAGE_SCORE
Numeric

Distinct count16
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.028276542
Minimum0
Maximum15
Zeros (%)79.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile14
Maximum15
Range15
Interquartile range0

Descriptive statistics

Standard deviation4.478501119
Coef of variation2.208032794
Kurtosis2.478873025
Mean2.028276542
MAD3.239452674
Skewness2.018256431
Sum104941
Variance20.05697227
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=16)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 7.5 8.5 10.5 11.5 12.5 13.5 14.5 15. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 41055 79.4%
 
15 2133 4.1%
 
14 1156 2.2%
 
13 889 1.7%
 
12 760 1.5%
 
8 668 1.3%
 
11 617 1.2%
 
10 559 1.1%
 
7 526 1.0%
 
5 513 1.0%
 
Other values (6) 2863 5.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 41055 79.4%
 
1 506 1.0%
 
2 418 0.8%
 
3 485 0.9%
 
4 464 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
15 2133 4.1%
 
14 1156 2.2%
 
13 889 1.7%
 
12 760 1.5%
 
11 617 1.2%
 

MON_TKT_BOUNCE_DATE
Categorical

Distinct count324
Unique (%)0.6%
Missing (%)0.0%
Missing (n)0
0
46655
3/12/2019 00:00
 
82
2/8/2018 00:00
 
77
Other values (321)
 
4925
ValueCountFrequency (%) 
0 46655 90.2%
 
3/12/2019 00:00 82 0.2%
 
2/8/2018 00:00 77 0.1%
 
3/9/2018 00:00 72 0.1%
 
12/31/2018 0:00 67 0.1%
 
2/27/2019 0:00 65 0.1%
 
4/9/2018 00:00 65 0.1%
 
1/9/2018 00:00 64 0.1%
 
3/27/2018 0:00 57 0.1%
 
1/8/2019 00:00 56 0.1%
 
Other values (314) 4479 8.7%
 
Max length16
Mean length2.307311699
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

MON_TKT_CLEARNACE_DATE
Categorical

Distinct count367
Unique (%)0.7%
Missing (%)0.0%
Missing (n)0
0
40667
10/8/2018 00:00
 
93
2/8/2019 00:00
 
87
Other values (364)
10892
ValueCountFrequency (%) 
0 40667 78.6%
 
10/8/2018 00:00 93 0.2%
 
2/8/2019 00:00 87 0.2%
 
3/31/2018 0:00 81 0.2%
 
9/10/2018 00:00 76 0.1%
 
2/8/2018 00:00 76 0.1%
 
7/23/2018 0:00 72 0.1%
 
1/9/2018 00:00 71 0.1%
 
3/9/2018 00:00 71 0.1%
 
7/9/2018 00:00 70 0.1%
 
Other values (357) 10375 20.1%
 
Max length16
Mean length3.844546667
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

MY_MON_BNC_SYS
Highly correlated

This variable is highly correlated with MON_BOUNCE_COUNT and should be ignored for analysis

Correlation0.948047586

MY_MON_CLR_SYS
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
40667
1
11072
ValueCountFrequency (%) 
0 40667 78.6%
 
1 11072 21.4%
 

new_policy
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
48611
1
 
3128
ValueCountFrequency (%) 
0 48611 94.0%
 
1 3128 6.0%
 

PLAN_CAT_01
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
46612
1
 
5127
ValueCountFrequency (%) 
0 46612 90.1%
 
1 5127 9.9%
 

PLAN_CAT_02
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50592
1
 
1147
ValueCountFrequency (%) 
0 50592 97.8%
 
1 1147 2.2%
 

PLAN_CAT_03
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
28542
1
23197
ValueCountFrequency (%) 
0 28542 55.2%
 
1 23197 44.8%
 

PLAN_CAT_04
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
44655
1
 
7084
ValueCountFrequency (%) 
0 44655 86.3%
 
1 7084 13.7%
 

PLAN_FAMILY_01
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
39474
1
12265
ValueCountFrequency (%) 
0 39474 76.3%
 
1 12265 23.7%
 

PLAN_FAMILY_02
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50240
1
 
1499
ValueCountFrequency (%) 
0 50240 97.1%
 
1 1499 2.9%
 

PLAN_FAMILY_03
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
48545
1
 
3194
ValueCountFrequency (%) 
0 48545 93.8%
 
1 3194 6.2%
 

PLAN_FAMILY_04
Highly correlated

This variable is highly correlated with PLAN_CAT_02 and should be ignored for analysis

Correlation0.9697120372

PLAN_FAMILY_05
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50283
1
 
1456
ValueCountFrequency (%) 
0 50283 97.2%
 
1 1456 2.8%
 

PLAN_FAMILY_06
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50630
1
 
1109
ValueCountFrequency (%) 
0 50630 97.9%
 
1 1109 2.1%
 

PLAN_FAMILY_07
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
48405
1
 
3334
ValueCountFrequency (%) 
0 48405 93.6%
 
1 3334 6.4%
 

PLAN_FAMILY_08
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51240
1
 
499
ValueCountFrequency (%) 
0 51240 99.0%
 
1 499 1.0%
 

PLAN_FAMILY_09
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
47548
1
 
4191
ValueCountFrequency (%) 
0 47548 91.9%
 
1 4191 8.1%
 

PLAN_FAMILY_10
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51635
1
 
104
ValueCountFrequency (%) 
0 51635 99.8%
 
1 104 0.2%
 

PLAN_FAMILY_11
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51594
1
 
145
ValueCountFrequency (%) 
0 51594 99.7%
 
1 145 0.3%
 

PLAN_FAMILY_12
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51517
1
 
222
ValueCountFrequency (%) 
0 51517 99.6%
 
1 222 0.4%
 

PLAN_FAMILY_13
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51684
1
 
55
ValueCountFrequency (%) 
0 51684 99.9%
 
1 55 0.1%
 

PLAN_FAMILY_14
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51682
1
 
57
ValueCountFrequency (%) 
0 51682 99.9%
 
1 57 0.1%
 

PLAN_FAMILY_15
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51127
1
 
612
ValueCountFrequency (%) 
0 51127 98.8%
 
1 612 1.2%
 

PLAN_FAMILY_16
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
45006
1
 
6733
ValueCountFrequency (%) 
0 45006 87.0%
 
1 6733 13.0%
 

PLAN_TYPE_01
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
30920
1
20819
ValueCountFrequency (%) 
0 30920 59.8%
 
1 20819 40.2%
 

PLAN_TYPE_02
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
49160
1
 
2579
ValueCountFrequency (%) 
0 49160 95.0%
 
1 2579 5.0%
 

PLAN_TYPE_03
Highly correlated

This variable is highly correlated with PLAN_CAT_01 and should be ignored for analysis

Correlation1

PLAN_TYPE_04
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
48869
1
 
2870
ValueCountFrequency (%) 
0 48869 94.5%
 
1 2870 5.5%
 

PLAN_TYPE_05
Highly correlated

This variable is highly correlated with PLAN_FAMILY_07 and should be ignored for analysis

Correlation0.9173916105

PLAN_TYPE_06
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50550
1
 
1189
ValueCountFrequency (%) 
0 50550 97.7%
 
1 1189 2.3%
 

PLAN_TYPE_07
Highly correlated

This variable is highly correlated with PLAN_FAMILY_14 and should be ignored for analysis

Correlation1

POL_COV_TERM
Numeric

Distinct count94
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean19.2259804
Minimum0
Maximum100
Zeros (%)29.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median20
Q325
95-th percentile62
Maximum100
Range100
Interquartile range25

Descriptive statistics

Standard deviation18.63247068
Coef of variation0.9691298071
Kurtosis1.699903182
Mean19.2259804
MAD13.30823946
Skewness1.278426865
Sum994733
Variance347.1689636
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 2.5 9. 10.5 12.5 ... 75.5 77.5 81.5 84.5 100. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 15185 29.3%
 
20 11751 22.7%
 
15 4609 8.9%
 
10 2427 4.7%
 
25 1735 3.4%
 
22 1435 2.8%
 
40 1405 2.7%
 
16 1324 2.6%
 
35 979 1.9%
 
30 697 1.3%
 
Other values (84) 10192 19.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 15185 29.3%
 
5 8 < 0.1%
 
8 1 < 0.1%
 
10 2427 4.7%
 
11 277 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
100 10 < 0.1%
 
99 9 < 0.1%
 
98 6 < 0.1%
 
97 15 < 0.1%
 
96 9 < 0.1%
 

POL_PPT
Numeric

Distinct count15
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean264.1892576
Minimum0
Maximum999
Zeros (%)29.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median10
Q3999
95-th percentile999
Maximum999
Range999
Interquartile range999

Descriptive statistics

Standard deviation435.4332141
Coef of variation1.648186675
Kurtosis-0.8009575582
Mean264.1892576
MAD381.8703732
Skewness1.094516882
Sum13668888
Variance189602.084
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%) 
0 15184 29.3%
 
999 13444 26.0%
 
10 7349 14.2%
 
6 5636 10.9%
 
12 2058 4.0%
 
8 1991 3.8%
 
20 1714 3.3%
 
5 1586 3.1%
 
15 1048 2.0%
 
7 701 1.4%
 
Other values (5) 1028 2.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 15184 29.3%
 
1 140 0.3%
 
3 18 < 0.1%
 
5 1586 3.1%
 
6 5636 10.9%
 

Maximum 5 values

ValueCountFrequency (%) 
999 13444 26.0%
 
60 341 0.7%
 
20 1714 3.3%
 
18 156 0.3%
 
15 1048 2.0%
 

POL_RIDER_COUNT
Numeric

Distinct count25
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.6829664276
Minimum0
Maximum31
Zeros (%)62.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile3
Maximum31
Range31
Interquartile range1

Descriptive statistics

Standard deviation1.227816008
Coef of variation1.797769199
Kurtosis67.30159999
Mean0.6829664276
MAD0.8472432245
Skewness5.248500953
Sum35336
Variance1.507532149
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=25)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 6.5 7.5 8.5 18.5 31. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 32092 62.0%
 
1 10199 19.7%
 
2 6170 11.9%
 
3 1947 3.8%
 
4 998 1.9%
 
6 133 0.3%
 
8 62 0.1%
 
5 27 0.1%
 
9 14 < 0.1%
 
7 14 < 0.1%
 
Other values (15) 83 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 32092 62.0%
 
1 10199 19.7%
 
2 6170 11.9%
 
3 1947 3.8%
 
4 998 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
31 2 < 0.1%
 
27 1 < 0.1%
 
26 2 < 0.1%
 
24 5 < 0.1%
 
22 2 < 0.1%
 

POLICY_CHNL_01
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
39108
1
12631
ValueCountFrequency (%) 
0 39108 75.6%
 
1 12631 24.4%
 

POLICY_CHNL_02
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
38721
1
13018
ValueCountFrequency (%) 
0 38721 74.8%
 
1 13018 25.2%
 

POLICY_CHNL_03
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51073
1
 
666
ValueCountFrequency (%) 
0 51073 98.7%
 
1 666 1.3%
 

POLICY_CHNL_04
Highly correlated

This variable is highly correlated with PLAN_TYPE_03 and should be ignored for analysis

Correlation0.9023277115

POLICY_CHNL_05
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
47380
1
 
4359
ValueCountFrequency (%) 
0 47380 91.6%
 
1 4359 8.4%
 

POLICY_CHNL_06
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50232
1
 
1507
ValueCountFrequency (%) 
0 50232 97.1%
 
1 1507 2.9%
 

POS_COUNT
Numeric

Distinct count14
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.1410541371
Minimum0
Maximum16
Zeros (%)89.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum16
Range16
Interquartile range0

Descriptive statistics

Standard deviation0.4813300223
Coef of variation3.412377915
Kurtosis89.49223133
Mean0.1410541371
MAD0.2515141474
Skewness6.387368416
Sum7298
Variance0.2316785903
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=14)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 6.5 8.5 16. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 46128 89.2%
 
1 4487 8.7%
 
2 804 1.6%
 
3 198 0.4%
 
4 75 0.1%
 
5 22 < 0.1%
 
6 11 < 0.1%
 
8 4 < 0.1%
 
7 4 < 0.1%
 
9 2 < 0.1%
 
Other values (4) 4 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 46128 89.2%
 
1 4487 8.7%
 
2 804 1.6%
 
3 198 0.4%
 
4 75 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
16 1 < 0.1%
 
15 1 < 0.1%
 
13 1 < 0.1%
 
11 1 < 0.1%
 
9 2 < 0.1%
 

POS_SYS_TOUCH_PT
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
46128
1
 
5611
ValueCountFrequency (%) 
0 46128 89.2%
 
1 5611 10.8%
 

POS_TKT_LOGGED_DATE1
Categorical

Distinct count389
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
0
46128
1/31/2018 0:00
 
55
11/20/2018 0:00
 
46
Other values (386)
 
5510
ValueCountFrequency (%) 
0 46128 89.2%
 
1/31/2018 0:00 55 0.1%
 
11/20/2018 0:00 46 0.1%
 
2/15/2019 0:00 46 0.1%
 
8/28/2018 0:00 43 0.1%
 
3/12/2019 00:00 40 0.1%
 
2/14/2018 0:00 40 0.1%
 
9/28/2018 0:00 38 0.1%
 
8/21/2018 0:00 37 0.1%
 
2/26/2019 0:00 37 0.1%
 
Other values (379) 5229 10.1%
 
Max length16
Mean length2.44049943
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

POS_VINTAGE_SCORE
Numeric

Distinct count16
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.103732194
Minimum0
Maximum15
Zeros (%)89.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile12
Maximum15
Range15
Interquartile range0

Descriptive statistics

Standard deviation3.523802501
Coef of variation3.192624551
Kurtosis8.451504601
Mean1.103732194
MAD1.976234505
Skewness3.145960195
Sum57106
Variance12.41718407
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=16)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 7.5 13.5 14.5 15. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 46302 89.5%
 
15 1521 2.9%
 
14 541 1.0%
 
13 360 0.7%
 
11 343 0.7%
 
10 338 0.7%
 
12 329 0.6%
 
8 311 0.6%
 
9 303 0.6%
 
7 229 0.4%
 
Other values (6) 1162 2.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 46302 89.5%
 
1 185 0.4%
 
2 205 0.4%
 
3 177 0.3%
 
4 181 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
15 1521 2.9%
 
14 541 1.0%
 
13 360 0.7%
 
12 329 0.6%
 
11 343 0.7%
 

REN_COUNT
Numeric

Distinct count18
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.3898606467
Minimum0
Maximum23
Zeros (%)82.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile3
Maximum23
Range23
Interquartile range0

Descriptive statistics

Standard deviation1.036213898
Coef of variation2.657908426
Kurtosis25.50924904
Mean0.3898606467
MAD0.6394019026
Skewness3.956195466
Sum20171
Variance1.073739242
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=18)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 6.5 7.5 11.5 15.5 23. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 42428 82.0%
 
1 3814 7.4%
 
2 2634 5.1%
 
3 1535 3.0%
 
4 745 1.4%
 
5 365 0.7%
 
6 93 0.2%
 
7 51 0.1%
 
8 19 < 0.1%
 
9 15 < 0.1%
 
Other values (8) 40 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 42428 82.0%
 
1 3814 7.4%
 
2 2634 5.1%
 
3 1535 3.0%
 
4 745 1.4%
 

Maximum 5 values

ValueCountFrequency (%) 
23 1 < 0.1%
 
16 1 < 0.1%
 
15 3 < 0.1%
 
14 3 < 0.1%
 
13 3 < 0.1%
 

REN_SYS_TOUCH_PT
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
42428
1
9311
ValueCountFrequency (%) 
0 42428 82.0%
 
1 9311 18.0%
 

REN_TKT_LOGGED_DATE1
Categorical

Distinct count390
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
0
42428
3/14/2019 0:00
 
82
3/20/2018 0:00
 
68
Other values (387)
9161
ValueCountFrequency (%) 
0 42428 82.0%
 
3/14/2019 0:00 82 0.2%
 
3/20/2018 0:00 68 0.1%
 
3/19/2018 0:00 53 0.1%
 
3/12/2018 00:00 51 0.1%
 
1/14/2019 0:00 50 0.1%
 
4/5/2018 00:00 49 0.1%
 
3/18/2018 0:00 49 0.1%
 
12/28/2018 0:00 48 0.1%
 
1/9/2018 00:00 48 0.1%
 
Other values (380) 8813 17.0%
 
Max length16
Mean length3.384100968
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

REN_VINTAGE_SCORE
Highly correlated

This variable is highly correlated with REN_SYS_TOUCH_PT and should be ignored for analysis

Correlation0.9115846582

SCP_EML_SCP_EM_1
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
47870
1
 
3534
2
 
315
ValueCountFrequency (%) 
0 47870 92.5%
 
1 3534 6.8%
 
2 315 0.6%
 
3 20 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_10
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51424
1
 
305
2
 
10
ValueCountFrequency (%) 
0 51424 99.4%
 
1 305 0.6%
 
2 10 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_13
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50957
1
 
780
2
 
2
ValueCountFrequency (%) 
0 50957 98.5%
 
1 780 1.5%
 
2 2 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_14
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51611
1
 
124
2
 
4
ValueCountFrequency (%) 
0 51611 99.8%
 
1 124 0.2%
 
2 4 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_15
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51581
1
 
158
ValueCountFrequency (%) 
0 51581 99.7%
 
1 158 0.3%
 

SCP_EML_SCP_EM_16
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51617
1
 
121
2
 
1
ValueCountFrequency (%) 
0 51617 99.8%
 
1 121 0.2%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_17
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51617
1
 
122
ValueCountFrequency (%) 
0 51617 99.8%
 
1 122 0.2%
 

SCP_EML_SCP_EM_18
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51283
1
 
446
2
 
10
ValueCountFrequency (%) 
0 51283 99.1%
 
1 446 0.9%
 
2 10 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_19
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51028
1
 
645
2
 
64
ValueCountFrequency (%) 
0 51028 98.6%
 
1 645 1.2%
 
2 64 0.1%
 
3 2 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_2
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
48051
1
 
3586
2
 
102
ValueCountFrequency (%) 
0 48051 92.9%
 
1 3586 6.9%
 
2 102 0.2%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_3
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
49573
1
 
2059
2
 
106
ValueCountFrequency (%) 
0 49573 95.8%
 
1 2059 4.0%
 
2 106 0.2%
 
3 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_4
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50769
1
 
916
2
 
54
ValueCountFrequency (%) 
0 50769 98.1%
 
1 916 1.8%
 
2 54 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_5
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50880
1
 
816
2
 
39
ValueCountFrequency (%) 
0 50880 98.3%
 
1 816 1.6%
 
2 39 0.1%
 
3 4 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_6
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50658
1
 
1045
2
 
36
ValueCountFrequency (%) 
0 50658 97.9%
 
1 1045 2.0%
 
2 36 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_7
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51232
1
 
505
2
 
2
ValueCountFrequency (%) 
0 51232 99.0%
 
1 505 1.0%
 
2 2 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_8
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
50776
1
 
934
2
 
29
ValueCountFrequency (%) 
0 50776 98.1%
 
1 934 1.8%
 
2 29 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EM_9
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51223
1
 
497
2
 
18
ValueCountFrequency (%) 
0 51223 99.0%
 
1 497 1.0%
 
2 18 < 0.1%
 
3 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_EML_SCP_EML_OTHERS
Numeric

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.140976826
Minimum0
Maximum5
Zeros (%)88.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.4237369904
Coef of variation3.005720887
Kurtosis17.64244909
Mean0.140976826
MAD0.2488695062
Skewness3.680699936
Sum7294
Variance0.1795530371
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=6)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 5. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 45668 88.3%
 
1 5070 9.8%
 
2 836 1.6%
 
3 118 0.2%
 
4 37 0.1%
 
5 10 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 45668 88.3%
 
1 5070 9.8%
 
2 836 1.6%
 
3 118 0.2%
 
4 37 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5 10 < 0.1%
 
4 37 0.1%
 
3 118 0.2%
 
2 836 1.6%
 
1 5070 9.8%
 

SCP_EML_SYS
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
35652
1
16087
ValueCountFrequency (%) 
0 35652 68.9%
 
1 16087 31.1%
 

SCP_SMS_AGENT_-_OTHER
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.002802528074
Minimum0
Maximum4
Zeros (%)99.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum4
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.07622283027
Coef of variation27.19788286
Kurtosis914.1436162
Mean0.002802528074
MAD0.005597039484
Skewness29.00202748
Sum145
Variance0.005809919854
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=5)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51665 99.9%
 
2 63 0.1%
 
1 8 < 0.1%
 
4 2 < 0.1%
 
3 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51665 99.9%
 
1 8 < 0.1%
 
2 63 0.1%
 
3 1 < 0.1%
 
4 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4 2 < 0.1%
 
3 1 < 0.1%
 
2 63 0.1%
 
1 8 < 0.1%
 
0 51665 99.9%
 

SCP_SMS_CUSTOMER_AWARENESS
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51406
1
 
320
2
 
13
ValueCountFrequency (%) 
0 51406 99.4%
 
1 320 0.6%
 
2 13 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_SMS_LAPSATION_&_REVIVAL
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.02141518004
Minimum0
Maximum4
Zeros (%)98.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum4
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.1516764959
Coef of variation7.082662655
Kurtosis67.58384427
Mean0.02141518004
MAD0.04195370318
Skewness7.638771988
Sum1108
Variance0.02300575941
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=5)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50680 98.0%
 
1 1013 2.0%
 
2 44 0.1%
 
4 1 < 0.1%
 
3 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50680 98.0%
 
1 1013 2.0%
 
2 44 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4 1 < 0.1%
 
3 1 < 0.1%
 
2 44 0.1%
 
1 1013 2.0%
 
0 50680 98.0%
 

SCP_SMS_MOBILE_NUMBER_LINK
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51687
1
 
52
ValueCountFrequency (%) 
0 51687 99.9%
 
1 52 0.1%
 

SCP_SMS_PAYMENT
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51695
1
 
43
2
 
1
ValueCountFrequency (%) 
0 51695 99.9%
 
1 43 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_SMS_PAYMENT_MODE
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.1664894954
Minimum0
Maximum12
Zeros (%)88.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum12
Range12
Interquartile range0

Descriptive statistics

Standard deviation0.6491751232
Coef of variation3.899195693
Kurtosis94.3362241
Mean0.1664894954
MAD0.2959734592
Skewness8.052499865
Sum8614
Variance0.4214283406
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 5.5 9. 12. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 45989 88.9%
 
1 4345 8.4%
 
2 991 1.9%
 
4 149 0.3%
 
6 73 0.1%
 
8 71 0.1%
 
3 71 0.1%
 
10 29 0.1%
 
12 11 < 0.1%
 
5 10 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 45989 88.9%
 
1 4345 8.4%
 
2 991 1.9%
 
3 71 0.1%
 
4 149 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
12 11 < 0.1%
 
10 29 0.1%
 
8 71 0.1%
 
6 73 0.1%
 
5 10 < 0.1%
 

SCP_SMS_POS
Constant

This variable is constant and should be ignored for analysis

Constant value0

SCP_SMS_PREMIUM_PAYMENT
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.1776029687
Minimum0
Maximum8
Zeros (%)86.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.497762715
Coef of variation2.802671141
Kurtosis13.88194025
Mean0.1776029687
MAD0.3076085204
Skewness3.311780928
Sum9189
Variance0.2477677204
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=8)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 8. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 44806 86.6%
 
1 4918 9.5%
 
2 1884 3.6%
 
4 86 0.2%
 
3 36 0.1%
 
5 5 < 0.1%
 
6 3 < 0.1%
 
8 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 44806 86.6%
 
1 4918 9.5%
 
2 1884 3.6%
 
3 36 0.1%
 
4 86 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 < 0.1%
 
6 3 < 0.1%
 
5 5 < 0.1%
 
4 86 0.2%
 
3 36 0.1%
 

SCP_SMS_PROPOSAL
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.08583467017
Minimum0
Maximum4
Zeros (%)94.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum4
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.3746945418
Coef of variation4.365305314
Kurtosis20.54305393
Mean0.08583467017
MAD0.1621069012
Skewness4.565623941
Sum4441
Variance0.1403959996
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=5)
Histogram
Histogram with variable size bins (bins=[0. 0.5 2.5 3.5 4. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 48857 94.4%
 
2 1482 2.9%
 
1 1363 2.6%
 
3 34 0.1%
 
4 3 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 48857 94.4%
 
1 1363 2.6%
 
2 1482 2.9%
 
3 34 0.1%
 
4 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4 3 < 0.1%
 
3 34 0.1%
 
2 1482 2.9%
 
1 1363 2.6%
 
0 48857 94.4%
 

SCP_SMS_RENEWAL
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.03960262085
Minimum0
Maximum7
Zeros (%)97.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum7
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.2715758013
Coef of variation6.857520929
Kurtosis103.0957719
Mean0.03960262085
MAD0.07709418372
Skewness8.976984809
Sum2049
Variance0.07375341586
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=8)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 7. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50360 97.3%
 
1 883 1.7%
 
2 381 0.7%
 
3 72 0.1%
 
4 31 0.1%
 
5 9 < 0.1%
 
6 2 < 0.1%
 
7 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50360 97.3%
 
1 883 1.7%
 
2 381 0.7%
 
3 72 0.1%
 
4 31 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7 1 < 0.1%
 
6 2 < 0.1%
 
5 9 < 0.1%
 
4 31 0.1%
 
3 72 0.1%
 

SCP_SMS_SYS
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
35019
1
16720
ValueCountFrequency (%) 
0 35019 67.7%
 
1 16720 32.3%
 

SCP_SMS_TERMINATION
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51626
1
 
101
2
 
11
ValueCountFrequency (%) 
0 51626 99.8%
 
1 101 0.2%
 
2 11 < 0.1%
 
3 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SCP_SMS_WEBSITE_MESSAGE
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51658
1
 
81
ValueCountFrequency (%) 
0 51658 99.8%
 
1 81 0.2%
 

TICKET_DATE
Categorical

Distinct count404
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
1/29/2018 0:00
 
215
3/7/2018 00:00
 
208
1/22/2018 0:00
 
203
Other values (401)
51113
ValueCountFrequency (%) 
1/29/2018 0:00 215 0.4%
 
3/7/2018 00:00 208 0.4%
 
1/22/2018 0:00 203 0.4%
 
1/10/2018 00:00 203 0.4%
 
2/26/2018 0:00 202 0.4%
 
1/25/2018 0:00 202 0.4%
 
7/9/2018 00:00 202 0.4%
 
1/30/2018 0:00 200 0.4%
 
1/2/2018 00:00 200 0.4%
 
1/8/2019 00:00 199 0.4%
 
Other values (394) 49705 96.1%
 
Max length16
Mean length14.26726454
Min length14
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

TICKET_DATE_15D
Categorical

Distinct count404
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
1/14/2018 0:00
 
215
2/20/2018 0:00
 
208
1/7/2018 00:00
 
203
Other values (401)
51113
ValueCountFrequency (%) 
1/14/2018 0:00 215 0.4%
 
2/20/2018 0:00 208 0.4%
 
1/7/2018 00:00 203 0.4%
 
12/26/2017 0:00 203 0.4%
 
2/11/2018 00:00 202 0.4%
 
1/10/2018 00:00 202 0.4%
 
6/24/2018 0:00 202 0.4%
 
1/15/2018 0:00 200 0.4%
 
12/18/2017 0:00 200 0.4%
 
12/24/2018 0:00 199 0.4%
 
Other values (394) 49705 96.1%
 
Max length16
Mean length14.31179574
Min length14
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

TKT_LOGGED_DATE
Categorical

Distinct count51631
Unique (%)99.8%
Missing (%)0.0%
Missing (n)0
20SEP2018:10:15:22
 
2
04JAN2018:06:45:13
 
2
14MAR2019:08:12:53
 
2
Other values (51628)
51733
ValueCountFrequency (%) 
20SEP2018:10:15:22 2 < 0.1%
 
04JAN2018:06:45:13 2 < 0.1%
 
14MAR2019:08:12:53 2 < 0.1%
 
18AUG2018:08:55:03 2 < 0.1%
 
28JUL2018:10:51:44 2 < 0.1%
 
15MAR2019:05:18:13 2 < 0.1%
 
17MAR2018:09:27:13 2 < 0.1%
 
22MAR2018:07:56:43 2 < 0.1%
 
03SEP2018:08:28:34 2 < 0.1%
 
29OCT2018:05:07:35 2 < 0.1%
 
Other values (51621) 51719 > 99.9%
 
Max length18
Mean length18
Min length18
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

TKT_LOGGED_DATE1
Categorical

Distinct count45386
Unique (%)87.7%
Missing (%)0.0%
Missing (n)0
2/26/2019 7:02
 
5
10/17/2018 5:28
 
5
3/19/2019 12:22
 
5
Other values (45383)
51724
ValueCountFrequency (%) 
2/26/2019 7:02 5 < 0.1%
 
10/17/2018 5:28 5 < 0.1%
 
3/19/2019 12:22 5 < 0.1%
 
8/8/2018 06:27 5 < 0.1%
 
4/5/2018 06:44 5 < 0.1%
 
7/16/2018 9:20 5 < 0.1%
 
1/20/2018 5:51 5 < 0.1%
 
2/1/2018 05:52 5 < 0.1%
 
7/9/2018 08:17 4 < 0.1%
 
4/27/2018 6:02 4 < 0.1%
 
Other values (45376) 51691 99.9%
 
Max length16
Mean length14.44075069
Min length14
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

UNO_CS_COMM_COUNT
Highly correlated

This variable is highly correlated with DELIVERY_STATUS and should be ignored for analysis

Correlation0.9563908587

UNO_CS_COMM_SYS
Highly correlated

This variable is highly correlated with COMM_VINTAGE_SCORE and should be ignored for analysis

Correlation0.9118394033

UNO_EML_ACCOUNT_VALUE/_SURRENDER_VALUE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51678
1
 
60
3
 
1
ValueCountFrequency (%) 
0 51678 99.9%
 
1 60 0.1%
 
3 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_BONUS_INQUIRY
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51687
1
 
50
3
 
1
ValueCountFrequency (%) 
0 51687 99.9%
 
1 50 0.1%
 
3 1 < 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_CAMPAIGN_RELATED_INFORMATION
Numeric

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.003421017028
Minimum0
Maximum5
Zeros (%)99.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.07039624874
Coef of variation20.57757917
Kurtosis1270.305004
Mean0.003421017028
MAD0.006822065615
Skewness29.60723533
Sum177
Variance0.004955631837
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=6)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 5. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51588 99.7%
 
1 134 0.3%
 
2 12 < 0.1%
 
4 2 < 0.1%
 
3 2 < 0.1%
 
5 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51588 99.7%
 
1 134 0.3%
 
2 12 < 0.1%
 
3 2 < 0.1%
 
4 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 < 0.1%
 
4 2 < 0.1%
 
3 2 < 0.1%
 
2 12 < 0.1%
 
1 134 0.3%
 

UNO_EML_DOCUMENTATION_REQUIREMENT_FOR_POS_CHANGES
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51684
1
 
53
3
 
1
ValueCountFrequency (%) 
0 51684 99.9%
 
1 53 0.1%
 
3 1 < 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_DUE_DATE/_AMOUNT
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51599
1
 
135
2
 
5
ValueCountFrequency (%) 
0 51599 99.7%
 
1 135 0.3%
 
2 5 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_ECS_/_CREDIT_CARD_INQUIRY
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51711
1
 
27
2
 
1
ValueCountFrequency (%) 
0 51711 99.9%
 
1 27 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_ECS_DEBIT_INCORRECT_/_NOT_DONE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51706
1
 
32
2
 
1
ValueCountFrequency (%) 
0 51706 99.9%
 
1 32 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_FOLLOW_UP_-_STATUS_OF_PROPOSAL
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51693
1
 
44
2
 
2
ValueCountFrequency (%) 
0 51693 99.9%
 
1 44 0.1%
 
2 2 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_KYC_DOCUMENT_STATUS
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51692
1
 
45
2
 
2
ValueCountFrequency (%) 
0 51692 99.9%
 
1 45 0.1%
 
2 2 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_MISS-SELLING_/_FRAUD_BY_AGENT
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51723
1
 
14
3
 
1
ValueCountFrequency (%) 
0 51723 > 99.9%
 
1 14 < 0.1%
 
3 1 < 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_OTHERS
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.04122615435
Minimum0
Maximum7
Zeros (%)97.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum7
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.2671705809
Coef of variation6.480608854
Kurtosis108.1798278
Mean0.04122615435
MAD0.07997582312
Skewness8.913708665
Sum2133
Variance0.07138011931
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=8)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 7. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50185 97.0%
 
1 1140 2.2%
 
2 302 0.6%
 
3 77 0.1%
 
4 24 < 0.1%
 
5 6 < 0.1%
 
6 3 < 0.1%
 
7 2 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50185 97.0%
 
1 1140 2.2%
 
2 302 0.6%
 
3 77 0.1%
 
4 24 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7 2 < 0.1%
 
6 3 < 0.1%
 
5 6 < 0.1%
 
4 24 < 0.1%
 
3 77 0.1%
 

UNO_EML_PERSONAL_UPDATE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51706
1
 
31
2
 
2
ValueCountFrequency (%) 
0 51706 99.9%
 
1 31 0.1%
 
2 2 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_POLICY_BENEFITS_/_DEATH_BENEFIT
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51674
1
 
64
2
 
1
ValueCountFrequency (%) 
0 51674 99.9%
 
1 64 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_POLICY_SERVICING_-_CLARIFICATION/_FOLLOW_UP
Numeric

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.007151278533
Minimum0
Maximum5
Zeros (%)99.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.09645560879
Coef of variation13.48788309
Kurtosis557.678325
Mean0.007151278533
MAD0.01421050365
Skewness18.98991265
Sum370
Variance0.009303684467
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=6)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 5. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51406 99.4%
 
1 308 0.6%
 
2 19 < 0.1%
 
5 2 < 0.1%
 
4 2 < 0.1%
 
3 2 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51406 99.4%
 
1 308 0.6%
 
2 19 < 0.1%
 
3 2 < 0.1%
 
4 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5 2 < 0.1%
 
4 2 < 0.1%
 
3 2 < 0.1%
 
2 19 < 0.1%
 
1 308 0.6%
 

UNO_EML_POLICY_STATUS_-_ACTIVE_/_LAPSE
Numeric

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.01107481784
Minimum0
Maximum5
Zeros (%)99.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.1237761714
Coef of variation11.17636183
Kurtosis267.163646
Mean0.01107481784
MAD0.02194243368
Skewness14.25567369
Sum573
Variance0.0153205406
Memory size404.3 KiB
Histogram
Histogram with fixed size bins (bins=6)
Histogram
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 5. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51255 99.1%
 
1 415 0.8%
 
2 52 0.1%
 
3 15 < 0.1%
 
5 1 < 0.1%
 
4 1 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51255 99.1%
 
1 415 0.8%
 
2 52 0.1%
 
3 15 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 < 0.1%
 
4 1 < 0.1%
 
3 15 < 0.1%
 
2 52 0.1%
 
1 415 0.8%
 

UNO_EML_POS_REQUEST_DELAY_/_ERROR
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51711
1
 
25
2
 
3
ValueCountFrequency (%) 
0 51711 99.9%
 
1 25 < 0.1%
 
2 3 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_PROCESSING_DELAY_/_ERROR
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51638
1
 
90
2
 
10
ValueCountFrequency (%) 
0 51638 99.8%
 
1 90 0.2%
 
2 10 < 0.1%
 
4 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

UNO_EML_SYS
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
49007
1
 
2732
ValueCountFrequency (%) 
0 49007 94.7%
 
1 2732 5.3%
 

UNO_EML_THIRD_PARTY_VERIFICATION
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
51713
1
 
25
2
 
1
ValueCountFrequency (%) 
0 51713 99.9%
 
1 25 < 0.1%
 
2 1 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Correlations

Missing values

Sample

First rows

CLEAN_INTENTCLI_EDUCATION_CAT_01CLI_EDUCATION_CAT_02CLI_EDUCATION_CAT_03CLI_EDUCATION_CAT_04CLI_HNI_IND_LCLI_HNI_IND_NCLI_HNI_IND_YCLI_OCCUPATION_CAT_01CLI_OCCUPATION_CAT_02CLI_OCCUPATION_CAT_03CLI_OCCUPATION_CAT_04CLI_OCCUPATION_CAT_05CLI_OCCUPATION_CAT_06CLI_OCCUPATION_CAT_07CLI_OCCUPATION_CAT_08CLI_SNGL_MLTPL_PLCYHLDR_FLG_MULTIPLECLI_SNGL_MLTPL_PLCYHLDR_FLG_SINGLECOMM_TKT_DTCOMM_VINTAGE_SCOREDELIVERY_STATUSDUE_DATE_PAIDDUE_DATE_SYSDUE_STS_SYSDUE_VINTAGE_SCOREECS_FLAG_NoECS_FLAG_YesHELP_LINE_ACCOUNTVALUE/SURRENDERVALUEHELP_LINE_BONUSINQUIRYHELP_LINE_DUEDATE/AMOUNTHELP_LINE_ECS/CREDITCARDINQUIRYHELP_LINE_LOANENQUIRYHELP_LINE_OTHERSHELP_LINE_PAYMENTPROCEDURE/ONLINEPAYMENTPROCEDUREHELP_LINE_POLICYPACKDISPATCHSTATUS/CLARIFICATIONHELP_LINE_POLICYSTATUS-ACTIVE/LAPSEHELP_LINE_POSREQUESTSTATUSREQUIREDHELP_LINE_PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRYHELP_LINE_PREMIUMRECEIPTREQUESTHELP_LINE_PROBABLESURRENDERHELP_LINE_STATUSOFTHEPROPOSALHELP_LINE_SYSINCOME_BUK_01INCOME_BUK_02INCOME_BUK_03INCOME_BUK_04INCOME_BUK_05ind_surrIVR_ACCOUNT_VALUE/_SURRENDER_VALUEIVR_OTHERSIVR_POLICY_STATUS_-_ACTIVE_/_LAPSEIVR_PREMIUM_RECEIPT_REQUESTIVR_SYSLock_in_indmapped_pol_idMEGA_MEGA_OTHERSMEGA_SCP_MG_1MEGA_SCP_MG_10MEGA_SCP_MG_11MEGA_SCP_MG_12MEGA_SCP_MG_13MEGA_SCP_MG_14MEGA_SCP_MG_2MEGA_SCP_MG_3MEGA_SCP_MG_4MEGA_SCP_MG_5MEGA_SCP_MG_6MEGA_SCP_MG_7MEGA_SCP_MG_9MEGA_SYSMON_BNC_CHQ_VINTAGE_SCOREMON_BOUNCE_COUNTMON_CLEARANCE_COUNTMON_CLR_CHQ_VINTAGE_SCOREMON_TKT_BOUNCE_DATEMON_TKT_CLEARNACE_DATEMY_MON_BNC_SYSMY_MON_CLR_SYSnew_policyPLAN_CAT_01PLAN_CAT_02PLAN_CAT_03PLAN_CAT_04PLAN_FAMILY_01PLAN_FAMILY_02PLAN_FAMILY_03PLAN_FAMILY_04PLAN_FAMILY_05PLAN_FAMILY_06PLAN_FAMILY_07PLAN_FAMILY_08PLAN_FAMILY_09PLAN_FAMILY_10PLAN_FAMILY_11PLAN_FAMILY_12PLAN_FAMILY_13PLAN_FAMILY_14PLAN_FAMILY_15PLAN_FAMILY_16PLAN_TYPE_01PLAN_TYPE_02PLAN_TYPE_03PLAN_TYPE_04PLAN_TYPE_05PLAN_TYPE_06PLAN_TYPE_07POL_COV_TERMPOL_PPTPOL_RIDER_COUNTPOLICY_CHNL_01POLICY_CHNL_02POLICY_CHNL_03POLICY_CHNL_04POLICY_CHNL_05POLICY_CHNL_06POS_COUNTPOS_SYS_TOUCH_PTPOS_TKT_LOGGED_DATE1POS_VINTAGE_SCOREREN_COUNTREN_SYS_TOUCH_PTREN_TKT_LOGGED_DATE1REN_VINTAGE_SCORESCP_EML_SCP_EM_1SCP_EML_SCP_EM_10SCP_EML_SCP_EM_13SCP_EML_SCP_EM_14SCP_EML_SCP_EM_15SCP_EML_SCP_EM_16SCP_EML_SCP_EM_17SCP_EML_SCP_EM_18SCP_EML_SCP_EM_19SCP_EML_SCP_EM_2SCP_EML_SCP_EM_3SCP_EML_SCP_EM_4SCP_EML_SCP_EM_5SCP_EML_SCP_EM_6SCP_EML_SCP_EM_7SCP_EML_SCP_EM_8SCP_EML_SCP_EM_9SCP_EML_SCP_EML_OTHERSSCP_EML_SYSSCP_SMS_AGENT_-_OTHERSCP_SMS_CUSTOMER_AWARENESSSCP_SMS_LAPSATION_&_REVIVALSCP_SMS_MOBILE_NUMBER_LINKSCP_SMS_PAYMENTSCP_SMS_PAYMENT_MODESCP_SMS_POSSCP_SMS_PREMIUM_PAYMENTSCP_SMS_PROPOSALSCP_SMS_RENEWALSCP_SMS_SYSSCP_SMS_TERMINATIONSCP_SMS_WEBSITE_MESSAGETICKET_DATETICKET_DATE_15DTKT_LOGGED_DATETKT_LOGGED_DATE1UNO_CS_COMM_COUNTUNO_CS_COMM_SYSUNO_EML_ACCOUNT_VALUE/_SURRENDER_VALUEUNO_EML_BONUS_INQUIRYUNO_EML_CAMPAIGN_RELATED_INFORMATIONUNO_EML_DOCUMENTATION_REQUIREMENT_FOR_POS_CHANGESUNO_EML_DUE_DATE/_AMOUNTUNO_EML_ECS_/_CREDIT_CARD_INQUIRYUNO_EML_ECS_DEBIT_INCORRECT_/_NOT_DONEUNO_EML_FOLLOW_UP_-_STATUS_OF_PROPOSALUNO_EML_KYC_DOCUMENT_STATUSUNO_EML_MISS-SELLING_/_FRAUD_BY_AGENTUNO_EML_OTHERSUNO_EML_PERSONAL_UPDATEUNO_EML_POLICY_BENEFITS_/_DEATH_BENEFITUNO_EML_POLICY_SERVICING_-_CLARIFICATION/_FOLLOW_UPUNO_EML_POLICY_STATUS_-_ACTIVE_/_LAPSEUNO_EML_POS_REQUEST_DELAY_/_ERRORUNO_EML_PROCESSING_DELAY_/_ERRORUNO_EML_SYSUNO_EML_THIRD_PARTY_VERIFICATION
0DUEDATE/AMOUNT00010100100000010000000010000000000000000010000000000ZTAEBFBFOOVMWLAEOO0000000000000000000000000010001000000000000010000009099900100000000316/12/2018 00:0014000000000000000000000000000000006/13/2018 0:005/29/2018 0:0013JUN2018:07:33:026/13/2018 7:33000000000000000000000
1PROBABLESURRENDER010001000000001016/9/2018 00:00136000010000000001100001100001000000WLCGBFZTWLXRZTVMOO00000000000000000000000000100000000000000001100000016999101000000000000000000000000000000000000000000006/11/2018 00:005/27/2018 0:0011JUN2018:11:23:476/11/2018 11:23610000000000000000000
2PAYMENTPROCEDURE/ONLINEPAYMENTPROCEDURE000101001000000010004/19/2018 0:00111310000000000000000100000000000CGAEVMBFXRVMOOAEZT0000000000000000000000000001000000000000001010000002099930000100000114/13/2018 0:007000000000000000001100000000021004/21/2018 0:004/6/2018 00:0021APR2018:05:00:314/21/2018 5:00000000000000000000000
3PROBABLESURRENDER000000000000000000003/27/2019 0:00111200000000000000000000000000000XRZTAEVMWLZTXRDKXR00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003/30/2019 0:003/15/2019 0:0030MAR2019:10:24:123/30/2019 10:24000000000000000000000
4POLICYSTATUS-ACTIVE/LAPSE01000100100000001000000010000000000000000010000000000BFDKCGXRYSAEBFCGXR00000000000000000000000000101000000000000000100000020101010000000000000000000000000000000000000000000011/13/2018 0:0010/29/2018 0:0013NOV2018:05:42:2811/13/2018 5:42000000000000000000000
5DUEDATE/AMOUNT00100010100000010000000010000000000000000010000000000XRWLWLBFDKCGYSVMZT000000000000000000000000001010000000000000001000000206100001000000000000000000000000000000000000000006/12/2018 00:005/28/2018 0:0012JUN2018:04:26:036/12/2018 04:26000000000000000000000
6BONUSINQUIRY00000000000000000000000000000000000000000000000000000ZTAEZTVMDKAEXRXRWL00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002/9/2018 00:001/25/2018 0:0009FEB2018:12:27:052/9/2018 12:27000000000000000000000
7POSREQUESTSTATUSREQUIRED0001010010000000111/14/2018 0:00102000010000000000000101100000000000DKDKVMWLAEXRYSVMDK0000000000000000000000000001000000000000000110000001099930100001111/13/2018 0:00900000000000000000000000000000000000011/19/2018 0:0011/4/2018 00:0019NOV2018:06:59:5311/19/2018 6:59210000000000000000000
8DUEDATE/AMOUNT000000000000000005/12/2018 00:00525/11/2018 00:0011400000000000000011000000020011XRAEZTOOOOOOWLVMZT000000000000000000000001000000000000000000000000000000000000115/17/2018 0:00100000000000000000000002100000000101005/22/2018 0:005/7/2018 00:0022MAY2018:10:15:015/22/2018 10:15310000000000000000000
9PREMIUMRECEIPTREQUEST00100100001000001000000001000000000000000100000000000DKOOZTCGDKBFCGCGDK0000000000000000012010/10/2018 00:00010000100001000000000000001000209992010000000000000000000000000000000000000000000010/23/2018 0:0010/8/2018 00:0023OCT2018:06:58:5210/23/2018 6:58000000000000000000000

Last rows

CLEAN_INTENTCLI_EDUCATION_CAT_01CLI_EDUCATION_CAT_02CLI_EDUCATION_CAT_03CLI_EDUCATION_CAT_04CLI_HNI_IND_LCLI_HNI_IND_NCLI_HNI_IND_YCLI_OCCUPATION_CAT_01CLI_OCCUPATION_CAT_02CLI_OCCUPATION_CAT_03CLI_OCCUPATION_CAT_04CLI_OCCUPATION_CAT_05CLI_OCCUPATION_CAT_06CLI_OCCUPATION_CAT_07CLI_OCCUPATION_CAT_08CLI_SNGL_MLTPL_PLCYHLDR_FLG_MULTIPLECLI_SNGL_MLTPL_PLCYHLDR_FLG_SINGLECOMM_TKT_DTCOMM_VINTAGE_SCOREDELIVERY_STATUSDUE_DATE_PAIDDUE_DATE_SYSDUE_STS_SYSDUE_VINTAGE_SCOREECS_FLAG_NoECS_FLAG_YesHELP_LINE_ACCOUNTVALUE/SURRENDERVALUEHELP_LINE_BONUSINQUIRYHELP_LINE_DUEDATE/AMOUNTHELP_LINE_ECS/CREDITCARDINQUIRYHELP_LINE_LOANENQUIRYHELP_LINE_OTHERSHELP_LINE_PAYMENTPROCEDURE/ONLINEPAYMENTPROCEDUREHELP_LINE_POLICYPACKDISPATCHSTATUS/CLARIFICATIONHELP_LINE_POLICYSTATUS-ACTIVE/LAPSEHELP_LINE_POSREQUESTSTATUSREQUIREDHELP_LINE_PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRYHELP_LINE_PREMIUMRECEIPTREQUESTHELP_LINE_PROBABLESURRENDERHELP_LINE_STATUSOFTHEPROPOSALHELP_LINE_SYSINCOME_BUK_01INCOME_BUK_02INCOME_BUK_03INCOME_BUK_04INCOME_BUK_05ind_surrIVR_ACCOUNT_VALUE/_SURRENDER_VALUEIVR_OTHERSIVR_POLICY_STATUS_-_ACTIVE_/_LAPSEIVR_PREMIUM_RECEIPT_REQUESTIVR_SYSLock_in_indmapped_pol_idMEGA_MEGA_OTHERSMEGA_SCP_MG_1MEGA_SCP_MG_10MEGA_SCP_MG_11MEGA_SCP_MG_12MEGA_SCP_MG_13MEGA_SCP_MG_14MEGA_SCP_MG_2MEGA_SCP_MG_3MEGA_SCP_MG_4MEGA_SCP_MG_5MEGA_SCP_MG_6MEGA_SCP_MG_7MEGA_SCP_MG_9MEGA_SYSMON_BNC_CHQ_VINTAGE_SCOREMON_BOUNCE_COUNTMON_CLEARANCE_COUNTMON_CLR_CHQ_VINTAGE_SCOREMON_TKT_BOUNCE_DATEMON_TKT_CLEARNACE_DATEMY_MON_BNC_SYSMY_MON_CLR_SYSnew_policyPLAN_CAT_01PLAN_CAT_02PLAN_CAT_03PLAN_CAT_04PLAN_FAMILY_01PLAN_FAMILY_02PLAN_FAMILY_03PLAN_FAMILY_04PLAN_FAMILY_05PLAN_FAMILY_06PLAN_FAMILY_07PLAN_FAMILY_08PLAN_FAMILY_09PLAN_FAMILY_10PLAN_FAMILY_11PLAN_FAMILY_12PLAN_FAMILY_13PLAN_FAMILY_14PLAN_FAMILY_15PLAN_FAMILY_16PLAN_TYPE_01PLAN_TYPE_02PLAN_TYPE_03PLAN_TYPE_04PLAN_TYPE_05PLAN_TYPE_06PLAN_TYPE_07POL_COV_TERMPOL_PPTPOL_RIDER_COUNTPOLICY_CHNL_01POLICY_CHNL_02POLICY_CHNL_03POLICY_CHNL_04POLICY_CHNL_05POLICY_CHNL_06POS_COUNTPOS_SYS_TOUCH_PTPOS_TKT_LOGGED_DATE1POS_VINTAGE_SCOREREN_COUNTREN_SYS_TOUCH_PTREN_TKT_LOGGED_DATE1REN_VINTAGE_SCORESCP_EML_SCP_EM_1SCP_EML_SCP_EM_10SCP_EML_SCP_EM_13SCP_EML_SCP_EM_14SCP_EML_SCP_EM_15SCP_EML_SCP_EM_16SCP_EML_SCP_EM_17SCP_EML_SCP_EM_18SCP_EML_SCP_EM_19SCP_EML_SCP_EM_2SCP_EML_SCP_EM_3SCP_EML_SCP_EM_4SCP_EML_SCP_EM_5SCP_EML_SCP_EM_6SCP_EML_SCP_EM_7SCP_EML_SCP_EM_8SCP_EML_SCP_EM_9SCP_EML_SCP_EML_OTHERSSCP_EML_SYSSCP_SMS_AGENT_-_OTHERSCP_SMS_CUSTOMER_AWARENESSSCP_SMS_LAPSATION_&_REVIVALSCP_SMS_MOBILE_NUMBER_LINKSCP_SMS_PAYMENTSCP_SMS_PAYMENT_MODESCP_SMS_POSSCP_SMS_PREMIUM_PAYMENTSCP_SMS_PROPOSALSCP_SMS_RENEWALSCP_SMS_SYSSCP_SMS_TERMINATIONSCP_SMS_WEBSITE_MESSAGETICKET_DATETICKET_DATE_15DTKT_LOGGED_DATETKT_LOGGED_DATE1UNO_CS_COMM_COUNTUNO_CS_COMM_SYSUNO_EML_ACCOUNT_VALUE/_SURRENDER_VALUEUNO_EML_BONUS_INQUIRYUNO_EML_CAMPAIGN_RELATED_INFORMATIONUNO_EML_DOCUMENTATION_REQUIREMENT_FOR_POS_CHANGESUNO_EML_DUE_DATE/_AMOUNTUNO_EML_ECS_/_CREDIT_CARD_INQUIRYUNO_EML_ECS_DEBIT_INCORRECT_/_NOT_DONEUNO_EML_FOLLOW_UP_-_STATUS_OF_PROPOSALUNO_EML_KYC_DOCUMENT_STATUSUNO_EML_MISS-SELLING_/_FRAUD_BY_AGENTUNO_EML_OTHERSUNO_EML_PERSONAL_UPDATEUNO_EML_POLICY_BENEFITS_/_DEATH_BENEFITUNO_EML_POLICY_SERVICING_-_CLARIFICATION/_FOLLOW_UPUNO_EML_POLICY_STATUS_-_ACTIVE_/_LAPSEUNO_EML_POS_REQUEST_DELAY_/_ERRORUNO_EML_PROCESSING_DELAY_/_ERRORUNO_EML_SYSUNO_EML_THIRD_PARTY_VERIFICATION
51729BONUSINQUIRY00010100100000010000000010000000000000000010000000000BFCGVMDKYSVMBFOOCG000000000000000000000000001000100000000000001000000779991010000111/18/2018 0:00140000000000000000000000000000000000001/19/2018 0:001/4/2018 00:0019JAN2018:03:46:511/19/2018 3:46000000000000000000000
51730STATUSOFTHEPROPOSAL00000000000000000000000000000000000000000000000000000XRYSBFDKWLVMYSCGCG00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009/19/2018 0:009/4/2018 00:0019SEP2018:10:59:429/19/2018 10:59000000000000000000000
51731PREMIUMRECEIPTREQUEST0001100010000000110/27/2018 0:006110/31/2018 0:00111010001000000000001100000000000WLOOWLWLCGWLXRBFXR0000000000000000018010/29/2018 0:00010001000100000000000001000000709991010000000000000000000001100000001000000000000011/5/2018 00:0010/21/2018 0:0005NOV2018:05:20:4311/5/2018 05:20110000000000000000000
51732ECS/CREDITCARDINQUIRY001001000010000015/7/2018 00:00121000001000000000000000001000000000YSOOXRAEOOBFZTZTCG00000000100000100000000000010000000000000001000001010530000010000515/10/2018 00:0015000000000000000000000000000021005/10/2018 00:004/25/2018 0:0010MAY2018:08:17:575/10/2018 08:17210000000000000000000
51733ACCOUNTVALUE/SURRENDERVALUE00100100100000001000000001000000000000000100001000000DKOOOOOOVMYSBFYSCG1000000000000010000000000001000001000000000000010001572100000116/22/2018 0:0050000000000000000000000000000000000007/2/2018 00:006/17/2018 0:0002JUL2018:06:19:197/2/2018 06:19000000000000000000000
51734PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY00100010100000001000000010000000000000000000010000000DKDKDKWLVMYSYSDKWL00000000000000000000000000010000000000000001000100019521000000000216/19/2018 0:0012000000000000000000000000000011006/22/2018 0:006/7/2018 00:0022JUN2018:03:57:476/22/2018 3:57000000000000000000000
51735DUEDATE/AMOUNT00100100100000001000000001000000000000000100000000000DKOOAEAEOOYSVMXRBF000000000000000000000000000100001000000000000001000209994100000111/15/2019 0:00140000000000000000000000000000100001001/16/2019 0:001/1/2019 00:0016JAN2019:10:14:331/16/2019 10:14000000000000000000000
51736ACCOUNTVALUE/SURRENDERVALUE00100100100000001000000001000000000000000010000000000BFXRXRWLVMXRWLVMWL00000000000000000000000000101000000000000000100000025120100000000000000000000000000000000000000000000010/31/2018 0:0010/16/2018 0:0031OCT2018:06:32:5010/31/2018 6:32000000000000000000000
51737STATUSOFTHEPROPOSAL0000000000000000011/26/2018 0:0014311/13/2018 0:0011100000000000000000000000000001XRZTOOAEAEYSWLDKXR00000000000000000115011/27/2018 0:00011000000000000000000000000000000000000000000000000000000000000000200000002010011/27/2018 0:0011/12/2018 00:0027NOV2018:07:55:3511/27/2018 7:55810000000000000000000
51738ACCOUNTVALUE/SURRENDERVALUE00100100001000010000000001000000000000000010000000000WLWLXROOWLYSVMBFAE000000000000000000000000001010000000000000001000000206100000100000000000000000000000000000000000000007/2/2018 00:006/17/2018 0:0002JUL2018:05:23:387/2/2018 05:23000000000000000000000